{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "bce44394",
   "metadata": {
    "pycharm": {
     "is_executing": false
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from pylab import mpl\n",
    "mpl.rcParams['font.sans-serif']=['SimHei']\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "\n",
    "data =pd.read_csv('地震数据3.csv',encoding='utf-8')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "548697e2",
   "metadata": {
    "pycharm": {
     "is_executing": false
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": "   Unnamed: 0     id              CATA_ID            SAVE_TIME  \\\n0        斐济群岛  42652  CC20210812114660.00  2021-08-12 12:07:50   \n1    河北唐山市滦州市  42651  CD20210812070716.00  2021-08-12 07:00:49   \n2    棉兰老岛附近海域  42650  CC20210812014615.00  2021-08-12 02:01:04   \n3    云南大理州漾濞县  42649  CD20210811191130.00  2021-08-11 19:06:03   \n4  新疆巴音郭楞州和静县  42647  CD20210811063958.00  2021-08-11 06:36:47   \n\n                O_TIME  EPI_LAT  EPI_LON  EPI_DEPTH AUTO_FLAG EQ_TYPE  ...  \\\n0  2021-08-12 11:46:59   -18.35  -177.85        500         M       M  ...   \n1  2021-08-12 07:07:15    39.69   118.50         14         M       M  ...   \n2  2021-08-12 01:46:14     6.50   126.80         40         M       M  ...   \n3  2021-08-11 19:11:29    25.70    99.87          9         M       M  ...   \n4  2021-08-11 06:39:57    42.93    84.28         10         M       M  ...   \n\n   M_MB2  SUM_STN  LOC_STN  LOCATION_C  LOCATION_S  CATA_TYPE  \\\n0      0        0        0        斐济群岛         NaN        NaN   \n1      0        0        0    河北唐山市滦州市         NaN        NaN   \n2      0        0        0    棉兰老岛附近海域         NaN        NaN   \n3      0        0        0    云南大理州漾濞县         NaN        NaN   \n4      0        0        0  新疆巴音郭楞州和静县         NaN        NaN   \n\n             SYNC_TIME  IS_DEL  EQ_CATA_TYPE           NEW_DID  \n0  2021-08-12 12:18:28     NaN           NaN  CC20210812114660  \n1  2021-08-12 07:11:27     NaN           NaN  CD20210812070716  \n2  2021-08-12 02:11:41     NaN           NaN  CC20210812014615  \n3  2021-08-11 19:16:40     NaN           NaN  CD20210811191130  \n4  2021-08-11 06:47:24     NaN           NaN  CD20210811063958  \n\n[5 rows x 26 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Unnamed: 0</th>\n      <th>id</th>\n      <th>CATA_ID</th>\n      <th>SAVE_TIME</th>\n      <th>O_TIME</th>\n      <th>EPI_LAT</th>\n      <th>EPI_LON</th>\n      <th>EPI_DEPTH</th>\n      <th>AUTO_FLAG</th>\n      <th>EQ_TYPE</th>\n      <th>...</th>\n      <th>M_MB2</th>\n      <th>SUM_STN</th>\n      <th>LOC_STN</th>\n      <th>LOCATION_C</th>\n      <th>LOCATION_S</th>\n      <th>CATA_TYPE</th>\n      <th>SYNC_TIME</th>\n      <th>IS_DEL</th>\n      <th>EQ_CATA_TYPE</th>\n      <th>NEW_DID</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>斐济群岛</td>\n      <td>42652</td>\n      <td>CC20210812114660.00</td>\n      <td>2021-08-12 12:07:50</td>\n      <td>2021-08-12 11:46:59</td>\n      <td>-18.35</td>\n      <td>-177.85</td>\n      <td>500</td>\n      <td>M</td>\n      <td>M</td>\n      <td>...</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>斐济群岛</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>2021-08-12 12:18:28</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>CC20210812114660</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>河北唐山市滦州市</td>\n      <td>42651</td>\n      <td>CD20210812070716.00</td>\n      <td>2021-08-12 07:00:49</td>\n      <td>2021-08-12 07:07:15</td>\n      <td>39.69</td>\n      <td>118.50</td>\n      <td>14</td>\n      <td>M</td>\n      <td>M</td>\n      <td>...</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>河北唐山市滦州市</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>2021-08-12 07:11:27</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>CD20210812070716</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>棉兰老岛附近海域</td>\n      <td>42650</td>\n      <td>CC20210812014615.00</td>\n      <td>2021-08-12 02:01:04</td>\n      <td>2021-08-12 01:46:14</td>\n      <td>6.50</td>\n      <td>126.80</td>\n      <td>40</td>\n      <td>M</td>\n      <td>M</td>\n      <td>...</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>棉兰老岛附近海域</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>2021-08-12 02:11:41</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>CC20210812014615</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>云南大理州漾濞县</td>\n      <td>42649</td>\n      <td>CD20210811191130.00</td>\n      <td>2021-08-11 19:06:03</td>\n      <td>2021-08-11 19:11:29</td>\n      <td>25.70</td>\n      <td>99.87</td>\n      <td>9</td>\n      <td>M</td>\n      <td>M</td>\n      <td>...</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>云南大理州漾濞县</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>2021-08-11 19:16:40</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>CD20210811191130</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>新疆巴音郭楞州和静县</td>\n      <td>42647</td>\n      <td>CD20210811063958.00</td>\n      <td>2021-08-11 06:36:47</td>\n      <td>2021-08-11 06:39:57</td>\n      <td>42.93</td>\n      <td>84.28</td>\n      <td>10</td>\n      <td>M</td>\n      <td>M</td>\n      <td>...</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>新疆巴音郭楞州和静县</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>2021-08-11 06:47:24</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>CD20210811063958</td>\n    </tr>\n  </tbody>\n</table>\n<p>5 rows × 26 columns</p>\n</div>"
     },
     "metadata": {},
     "output_type": "execute_result",
     "execution_count": 8
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "ed3a1c25",
   "metadata": {
    "pycharm": {
     "is_executing": false
    }
   },
   "outputs": [],
   "source": [
    "data_time = data['O_TIME']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "outputs": [
    {
     "data": {
      "text/plain": "0     2021-08-12 11:46:59\n1     2021-08-12 07:07:15\n2     2021-08-12 01:46:14\n3     2021-08-11 19:11:29\n4     2021-08-11 06:39:57\n5     2021-08-11 06:35:57\n6     2021-08-10 16:17:03\n7     2021-08-10 14:39:43\n8     2021-08-10 08:38:33\n9     2021-08-09 18:51:25\n10    2021-08-09 06:54:17\n11    2021-08-09 06:17:56\n12    2021-08-08 18:13:42\n13    2021-08-07 03:22:02\n14    2021-08-06 21:18:48\n15    2021-08-06 19:12:30\n16    2021-08-06 19:08:16\n17    2021-08-06 16:11:04\n18    2021-08-06 10:38:51\n19    2021-08-06 09:48:34\nName: O_TIME, dtype: object"
     },
     "metadata": {},
     "output_type": "execute_result",
     "execution_count": 10
    }
   ],
   "source": [
    "data_time"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n",
     "is_executing": false
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  },
  "pycharm": {
   "stem_cell": {
    "cell_type": "raw",
    "source": [],
    "metadata": {
     "collapsed": false
    }
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}